After loading content, the data model should be analyzed to maximize efficiency.
(Re)analyzes all tables/indexes within the entire data model. This is a single call that performs the equivalent operations of calling AnalyzeCore, followed by AnalyzeStore on each data model store. It is recommended that the System Administrator run this procedure after a bulk load or on a scheduled basis if content loads are made on a more frequent basis (as when loading customer authored content).
See Executing the Stored Procedure from SQL Plus for more information.